Skip to main content

How to connect your AWS database with Rocketadmin

This user guide outlines the procedure for establishing a Rocketadmin connection to an AWS database instance that operates on MySQL database engine.

Although the manual primarily focuses on MySQL as an example, it can also be utilized to establish connections with various other types of databases supported by Amazon.

note

The instructions are general and do not contain any detailed explanations on specific AWS features. To learn the fundamentals, find best practices and experience the full AWS potential, please visit https://docs.aws.amazon.com/.


AWS settings​

Before setting up the DB instance, you need to create a security group which acts as a virtual firewall and controls the inbound and outbound traffic of the database. In the next settings, you will directly add the Rocketadmin IP address to the inbound rules, granting us access to your database.


To create VPC security group​

  1. Sign in to the AWS Management Console and open the Amazon VPC console at https://console.aws.amazon.com/vpc/.

  2. In the navigation pane, click on Security groups:

  3. Click on Create security group:

  4. Enter a name and a description:

  1. Click on Add rule under Inbound rules:

  2. Provide the following information:

    • select MySQL/Aurora as rule Type

    • enter the Rocketadmin IP address 18.221.81.73/32 in the source field

  3. Navigate to the end of the page and click on Create security group:

The security group is visible in the list and ready to be associated with a DB instance.


To create a DB instance​

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the navigation pane, click on Databases:

  3. Click on Create database.

  4. In the next screen:

    • select Standard create:

    • select MySQL:

    • enter a name for your database instance in the Settings section:

    • provide your credential details:

    • In the Connectivity section select Yes for Public access:

    • In the VPC section mark the option Choose existing and select the security group which you created:

    • In the Additional configuration section enter a name for your database:

    • Navigate to the end of the page and click on Create database.


note

The creation process might take several minutes. Please wait until the database status becomes Available:


MySQL settings​

You need to create at least one table in your database. Use a MySQL command line client or a visual tool of your choice to access the AWS DB instance.

note

In order to connect to the database from your local server, you need to add its IP address to the inbound rules of the Amazon VPC security group.


To connect to the database​

  1. In the AWS DB instance details screen navigate to Connectivity and security and copy the endpoint of the database:

  2. Use your database management tool to connect to the AWS DB instance using the endpoint address and your database credentials:

  3. Once the connection is successful, create a table and populate it with data:


Rocketadmin settings​

The final steps of this guide include creating a Rocketadmin connection to the AWS instance running MySQL and review the data in the table. Follow the guidelines:

  1. Sign in to your Rocketadmin account.

  2. In the Dashboard click on Add database:

  3. In the Connect a database screen:

    • enter a name for the connection

    • select MySQL as database type

  4. Enter the following information in the connection's details:

    • Hostname: the AWS endpoint address of your instance

    • Username, Password, Database name

  5. Click on Test connection.

  6. Once the connection is successful, click on Add. The following message appears:

  7. Click on I gave access since the security group associated with the Rocketadmin IP has already been created.

Your database and table appear in the Dashboard: